using Lamex.Base.Framework.BaseAbs; 
using Lamex.Base.Framework.BaseDal; 
using  Lamex.SIESystemManager.Interface; 
using  Lamex.SIESystemManager.Model;
using System.Data; 
namespace Lamex.SIESystemManager.DalServer 
{
 public class B_IE_SJR_DATA : BaseDalSQL<B_IE_SJR_DATAInfo>,IB_IE_SJR_DATA
  {
     public DataSet SJDataSet()
     {
         string sql = @"SELECT  SJ.[IDNO]
      ,[PartNo]
      ,[Drawing_No]
      ,[Production_Size]
      ,[Insert_TS]
      ,[Insert_User]
      ,[Flag]
  FROM  [LamexMESManager].[dbo].[B_IE_SJR_DATA] SJ 
JOIN [Edgeband_Program].[dbo].[Initial_Data_SJ] DSJ  ON
SJ.PartNo=DSJ.PartNumber COLLATE Chinese_PRC_CI_AI_WS
where isnull(Flag,'')='' ";
         return base.GetDataSetBySql(sql);
     }
  }
};
